Notes/Domino 6 and 7 Forum : RE: Does "ReCache" work as described?

Andre,

Thanks for taking your time and testing this too. I appreciate your detailled response and I like your idea to initiate a "ReCache" at the time the data are saved and not when/where the data will be used. We will follow your suggestion and implement this troughout the application. However, we tried to do this in relation to our problem but it didn't work either.

In the same application we make quite a lot of use of "ReCache" and they all work, except of one situation.

In the application we create new documents (customer docs, address docs, order docs etc). Each document will get a new unique decimal number incremented by one for each new doc of its type, generated in a CWC field called AutoNumber using the following Formula:

SearchView := "OrderNumbersView" ;
ValueList := @DbColumn( "" : "ReCache" ; "" ; SearchView ; 1 ) ;
HighestValue := @Subset(ValueList ; 1 ) ;
@If( HighestValue = "" ; @Return(1) ; 1 ) ;
@If( HighestValue > 999998 ; @Return(1) ; 1 ) ;
HighestValue + 1

The Autonumber field is the only place where "ReCache" doesn't work. It doesn't matter on which form or SearchView (customers etc) the Autonumber will be used, "ReCache" doesn't work for in this field.

Btw, in this special database each employee has its personal copy of the database, so using incremental numbers is ok. There is a second field composed of this number and the employee number which will be transferres to an ERP application for further processing.

Notes/Domino 6 and 7 Forum

Document Options

Search this forum

Forum views and search

Member Tools

RSS Feeds